ALTER TABLE [X_Config] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Config] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Config] ON 
PRINT 'Begin inserting data in X_Config'
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(1, 'Title', '企业综合管理系统', '网站的标题')
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(5, 'PageSize', '20', '表格数据每页显示的个数')
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(6, 'MenuType', 'accordion', '菜单样式(手风琴式，树型菜单)')
SET IDENTITY_INSERT [X_Config] OFF 
ALTER TABLE [X_Config] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Config] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Log] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Log] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Log] ON 
PRINT 'Begin inserting data in X_Log'
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(13, '2009-08-19 13:57:38', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(14, '2009-08-19 14:03:54', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(15, '2009-08-19 14:05:37', '11', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(16, '2009-08-25 14:54:48', '10', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(17, '2009-08-25 15:24:28', '14', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(18, '2009-08-25 15:32:04', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(19, '2009-08-25 15:45:47', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(20, '2009-08-25 16:14:22', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(21, '2009-08-31 10:09:52', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(22, '2009-09-01 09:22:28', '7', 'WARN', 'AppBox._default', '登录失败：用户“admin”密码错误', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(23, '2009-09-01 09:22:29', '7', 'WARN', 'AppBox._default', '登录失败：用户“admin”密码错误', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(24, '2009-09-01 09:22:30', '7', 'WARN', 'AppBox._default', '登录失败：用户“admin”密码错误', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(25, '2009-09-01 09:22:34', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(26, '2009-09-08 15:32:50', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(27, '2009-09-08 15:41:17', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(28, '2009-09-08 16:30:42', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
SET IDENTITY_INSERT [X_Log] OFF 
ALTER TABLE [X_Log] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Log] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Menu] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Menu] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Menu] ON 
PRINT 'Begin inserting data in X_Menu'
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(2, '系统管理', '', '', '', 1, '', 0, 10, NULL, NULL, '2008-12-30 17:33:41', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(4, '职务管理', '', '', '~/admin/power.aspx', 1, '', 2, 30, NULL, NULL, '2008-12-31 10:46:04', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(5, '部门管理', '', '', '~/Module/department.aspx', 1, '', 2, 40, NULL, NULL, '2008-12-31 10:44:30', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(6, '菜单管理', '', '', '~/admin/menu.aspx', 1, '', 2, 20, NULL, NULL, '2008-12-31 10:15:07', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(7, '角色管理', '', '', '~/admin/role.aspx', 1, '', 2, 60, NULL, NULL, '2008-12-31 10:42:41', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(8, '用户管理', '', '', '~/admin/user.aspx', 1, '', 2, 70, NULL, NULL, '2008-12-31 10:44:42', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(9, '用户权限配置', NULL, NULL, '~/admin/userright.aspx', 1, NULL, 2, 80, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(10, '日志管理', NULL, NULL, '~/admin/log.aspx', 1, NULL, 2, 90, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(11, '办公平台', '', '', '', 1, '', 0, 100, NULL, NULL, '2008-12-31 09:29:39', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(12, '文件发布', '', '', '~/admin/file.aspx', 1, '', 11, 110, NULL, NULL, '2008-12-31 09:59:20', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(17, '菜单管理-查看', '', '', '~/admin/menu_view.aspx', 1, '', 6, 130, NULL, NULL, '2008-12-29 21:22:11', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(18, '菜单管理-编辑', '', '', '~/admin/menu_edit.aspx', 1, '', 6, 131, NULL, NULL, '2008-12-31 11:07:57', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(20, '菜单管理-新增', '', '', '~/admin/menu_new.aspx', 1, '', 6, 134, NULL, NULL, '2008-12-31 10:37:52', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [Tooltip], [ImageUrl], [NavigateUrl], [Show], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(24, '测试目录', NULL, NULL, '~/admin/test.aspx', 1, NULL, 11, 135, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [X_Menu] OFF 
ALTER TABLE [X_Menu] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Menu] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_User] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_User] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_User] ON 
PRINT 'Begin inserting data in X_User'
INSERT INTO [X_User] ([Id], [Name], [Password], [Email], [Enabled], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(3, 'admin', 'rSRPrSrj2eclC9avWKWZvJomw6+FPEN4', NULL, 1, NULL, '2008-12-27 18:13:51', 'AppBox.Web.Init', '2008-12-27 18:13:51', 'AppBox.Web.Init')
SET IDENTITY_INSERT [X_User] OFF 
ALTER TABLE [X_User] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_User] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_UserConfig] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_UserConfig] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_UserConfig] ON 
PRINT 'Begin inserting data in X_UserConfig'
SET IDENTITY_INSERT [X_UserConfig] OFF 
ALTER TABLE [X_UserConfig] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_UserConfig] ENABLE TRIGGER ALL
GO



